package com.ss.SmartStock.mapper;

import com.ss.SmartStock.pojo.dto.product.ProductQueryAllRequest;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProductQueryAll {

    /**
     * 关联查询
     * @return
     */
    @Select("SELECT * FROM product,product_details where product_details_id=p_details_id")
    List<ProductQueryAllRequest> userProductQueryAll();

}
